# coding: utf-8
from application import db


class MailAddress(db.Model):
    __tablename__ = 'mail_address'

    id = db.Column(db.Integer, primary_key=True)
    address = db.Column(db.String(50, 'utf8mb4_0900_ai_ci'))
    detail = db.Column(db.String(100, 'utf8mb4_0900_ai_ci'))
    name = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    phone = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    openid = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    mark = db.Column(db.Integer)